Community Priorities

Introduction

Solar power is the fastest growing renewable energy source. Community shared solar (CSS) projects lower the barrier to entry. This is accomplished by increasing the applicant pool by allowing those without rooftop access, such as renters or those in apartment buildings, and by lowering the financial burden of entry, as the fixed costs to install and operate the solar panels are collectivised rather than focused on one rooftop. CSS programs that are third-party owned and have participants subscribe to ongoing payments. Typically, within these programs, customers are given predefined, discrete contract terms rather than being able to compare multiple offerings or select their own terms. Our research is attempting to mimic this approach by giving customers a randomly assigned contract and surveying them on their willingness to adopt this program.

For potential customers, community solar contracts vary by their contract attributes. These include term length, cancellation fees, and potential savings rates relative to traditional utility bill companies. Given the importance of both the solar industry and the relatively incipient community solar industry, a dearth of research exists on how potential customer priorities are reflected in the likelihood of contract adoption.

This research seeks to fill this gap by developing quantitative measurements of community priorities in likelihood of contract adoption. An original data set comprised of potential community solar customers surveyed was collected. Along with respondents demographic information, draft contracts with varying degrees of contract attributes were shown to each participant and their contract adoption rates. Using a weighted logit model, the likelihood of contract adoption was analyzed by including predictors for various demographic data and contract attributes. Additionally, relative importance is through a multinomial logit model, allowing contract attributes and demographic information to be interpreted in predictive strength relative to respective reference groups.

Literature Review

to-do: to be added/folded into the Introduction to frame the macro-scope of this study

Methods

The community solar priorities research consists of an analysis of survey data in which each respondent was asked to evaluate two hypothetical community solar contracts with varying contract terms. Respondents also answered a number of demographic questions.

The contracts that respondents reviewed varied along the following features: (1) the program’s savings rate compared to the typical monthly electricity bill, (2) the program’s cancellation fee, (3) the contract term’s length in years, and (4) the page length of the contract.

In addition to basic descriptive analyses, the goal is to conduct two distinct analyses using the survey data. The primary analysis will use a logit model to estimate respondents’ stated willingness to enroll in the contracts they reviewed, controlling for available demographic characteristics. The secondary analysis will use an order multinomial logit model to estimate respondents’ stated willingness to enroll in a contract based on various contract terms as measured by a 5-point Likert scale.

Data Collection

Survey respondents were drawn from two sources: (1) members of the Qualtrics panel (“the Qualtrics sample”), and (2) individuals in community groups identified by Solstice (“the Community Group sample”). Combined, these two surveys represent the primary data source. Survey responses were collected in the Qualtrics sample from April 2021 to June 2021, and resulted in 1,261 individual responses. To expand the survey population, the Community Group sample was collected from December 2021 to June 2022, with 1,022 responses. Total responses resulted in 2,283. Response quality was measured in order to detect fraud or errant submissions. After this prophylactic step, a total of 1,493 unique individuals remained, with a total of 2,986 responses as each individual reviewed two contracts.

To make sure that enough of the respondents are from populations of interest, both of these data sources oversampled low-income respondents and people of color. To avoid biased estimates as a result of the overweighting in the survey design, survey weights are devised using state level ACS data for race. Weights are available as well for income, however due to the dynamic surveying of income used in the design of the survey weighting was opted for just race controls. Please reference the survey weights section for additional information.

The population for this component of our research is adults (18+) in the eight states we will include within this study: Massachusetts, New York, California, Oregon, Illinois, Maryland, Colorado and Minnesota. We have chosen to oversample-populations that are considered low- to moderate-income (LMI) defined as up to 50% and between 50%-80% of an area’s median income, in accordance with the Department of Housing and Urban Development’s (HUD) definitions of each term.. Dynamic surveying was deployed in which respondents are asked whether their income falls within the LMI ranges that correspond with their zip code and household size. This is the preferred approach for this research as it allows for comparing priorities across broad income categories and avoid non- response issues attached to asking respondents to self-attest their income levels. We have also chosen to oversample minority and renter populations in this research, surpassing the proportional estimates of these demographics supplied by the 2020 American Community Survey (ACS) estimates. We have designed this sampling scheme to center familiarity with community solar as a core demographic within this research, though we will not weight on this demographic due to lack of an applicable metric. By centering familiarity with community solar as a central demographic within this research, Solstice plans to incorporate respondents that are the likely next adopters of community solar and respondents from populations that are not currently effectively reached by community solar. All demographic information will be self-attested through the community solar priorities research survey.

Full copies of the survey questions are available on the github repository.

Descriptive Statistics

Table 1 shows the summary statistics for both the demographic and the contract attribute data. Contract varying terms such as savings rate, cancellation fee, contract pages and contract years were evenly divided so as to evaluate contract adoption rate relative to contract differences. Contracts were randomly assigned to responsees to review. The statistics below show how in aggregate, the distribution of contract attributes remained similar to their construction.

Demographic Comparison

Demographic data as reported in Table 1 reflects the oversampling of LMI, minority and renting communities. Graphs 1-3 show the proportion of each of these oversampled demographic categories in comparison totals. For race and income, comparison data is taken for the 8 state region from the 2020 5-year American Community Survey. Given the dynamic sampling used for income categories, control totals for income is taken from the Department of Housing and Urban Development’s Office of Policy Development and Research (PD&R) Comprehensive Housing Affordability Strategy Data (CHAS). The most recent CHAS data is available as of 2018 5-year data.

Race

Income

Homeownership

Model

A number of independent variables will be used for both contract attributes and demographic data. Interaction variables will be tested for significant, along with a initial stepwise regression to determine which variables to initially include. The below equation is a summary of the full model used in this analysis. The dependent variable is a binary variable for contract adoption, \(y_{signup}\), where 1 signifies the contract was adopted and 0 signifies it was not.

\[\begin{equation} y_{signup} = \beta_{0} + \beta_{1}x_{sr} +\beta_{2}x_{cly} +\beta_{3}x_{clp} +\beta_{4}x_{cf} + \\ \beta{5}x_{inc}+\beta_{6}x_{race} + \beta_{7}x_{hs} +\beta_{8}x_{fam} + \beta_{9}x_{rev} + \beta_{10}x_{ord}+ e_{i} \end{equation}\]

where,

  • \(x_{sr}\): savings rates on monthly energy bill in contracts, listed at either 5%, 10% or 20%
  • \(x_{cly}\): contract length years, either 1 or 25 years
  • \(x_{clp}\): contract length pages, either 10 or 20 pages
  • \(x_{cf}\): cancellation fee, either zero or $250
  • \(x_{inc}\): income, listed as Low (up to 50% of AMI), Moderate (50% - 120% of AMI), or High (>120% AMI)
  • \(x_{race}\): Categories include Asian, Black or African American, Hispanic or Latino, White and Other POC
  • \(x_{hs}\): Homeowner status for Homeowner, Renter or Other
  • \(x_{fam}\): More or less familiar with community solar
  • \(x_{rev}\): How much respondent reviewed the contract; up to half the contract review is captured by “less review”, over half and up to the whole contract is “more review”
  • \(x_{ord}\): Contract review order, likely not necessary.

Other variables of interest to consider: government program - x_govt

Results

Primary Analysis

Regression Tables

Stata Version:

library(RStata)
options("RStata.StataVersion" = 17)
#options("chooseStataBin"= "/Users/jacobford/Applications/Stata/StataSE")
#options(chooseStataBin('/Applications/Stata/StataSE.app/Contents/MacOS/stata-se'))

options("RStata.StataPath" = "/Applications/Stata/StataSE.app/Contents/MacOS/stata-se")
stata("/Volumes/GoogleDrive/Shared drives/*Solstice | Low Income Inclusion/Projects/2019-2022 DOE SETO Contract Innovations/DOE SETO Project Implementation/Project Management/SETO Data Analysis/1. Community Solar Priorities/Qualtrics Survey/seto_survey/scripts/test.do")
## Warning in readLines(SRC[1L]): incomplete final line found on '/Volumes/
## GoogleDrive/Shared drives/*Solstice | Low Income Inclusion/Projects/2019-2022
## DOE SETO Contract Innovations/DOE SETO Project Implementation/Project
## Management/SETO Data Analysis/1. Community Solar Priorities/Qualtrics Survey/
## seto_survey/scripts/test.do'
## . 
## .          use "/Volumes/GoogleDrive/Shared drives/*Solstice | Low Income Inclu
## > sion/Projects/2019-2022 DOE SETO Contract Innovations/DOE SETO Project Implem
## > entation/Project Management/SETO Data Analysis/1. Community Solar Priorities/
## > Qualtrics Survey/seto_survey/output/QUALTRICS_survey_data_all.dta", clear
## .          
## .         gen weight_income_int = int(weight_income)
## (2 missing values generated)
## .         gen weight_race_int = int(weight_race)
## (2 missing values generated)
## .          
## .          quietly logit y_signup i.x_sr [pweight=weight_race_int], cluster(id)
## .          
## .          estimates store m1, title(Model 1)
## .          
## .          
## .                 estout m1, replace cells(b(star fmt(3))) ///
## >                 legend label varlabels(_cons Constant) ///
## >                 ///mtitles("SR: None" "SR: 1-5" "SR: 6-10" "SR: 11-15") ///
## >                 title({\b Table 1.} {\i Logistic Regression: Contract Adoptio
## > n})
## 
## {\b Table 1.} {\i Logistic Regression: Contract Adoption}
## ------------------------------------
##                           Model 1   
##                                 b   
## ------------------------------------
## y_signup                            
## 5% savings rate             0.000   
## 10% savings rate            0.123   
## 20% savings rate            0.093   
## Constant                    0.314***
## ------------------------------------
## * p<0.05, ** p<0.01, *** p<0.001
## .                 
## .                 
## .                 
## .                 
## .         *--------------------------------------------------------------------
## > -------
## .         * Controlling for savings rate (x_sr)
## .         *--------------------------------------------------------------------
## > -------
## .         
## .         #delimit;
## delimiter now ;
## .         logit 
## >                 y_signup 
## >                 i.x_sr 
## >                 [pweight=weight_race_int]
## >                 ,
## >                 cluster(id)
## >         ;
## 
## Iteration 0:   log pseudolikelihood = -1.349e+08  
## Iteration 1:   log pseudolikelihood = -1.348e+08  
## Iteration 2:   log pseudolikelihood = -1.348e+08  
## 
## Logistic regression                                     Number of obs =  2,986
##                                                         Wald chi2(2)  =   1.54
##                                                         Prob > chi2   = 0.4632
## Log pseudolikelihood = -1.348e+08                       Pseudo R2     = 0.0005
## 
##                                  (Std. err. adjusted for 1,493 clusters in id)
## ------------------------------------------------------------------------------
##              |               Robust
##     y_signup | Coefficient  std. err.      z    P>|z|     [95% conf. interval]
## -------------+----------------------------------------------------------------
##         x_sr |
## 10% savin..  |    .122921   .1035151     1.19   0.235    -.0799649    .3258069
## 20% savin..  |   .0933878   .1010838     0.92   0.356    -.1047329    .2915084
##              |
##        _cons |   .3144514   .0820369     3.83   0.000     .1536621    .4752407
## ------------------------------------------------------------------------------
## .         #delimit cr 
## delimiter now cr
## .         
## .         estimates store m1, title(Model 1)
## .         
## .         margins x_sr 
## 
## Adjusted predictions                                     Number of obs = 2,986
## Model VCE: Robust
## 
## Expression: Pr(y_signup), predict()
## 
## ------------------------------------------------------------------------------
##              |            Delta-method
##              |     Margin   std. err.      z    P>|z|     [95% conf. interval]
## -------------+----------------------------------------------------------------
##         x_sr |
## 5% saving..  |   .5779714   .0200105    28.88   0.000     .5387516    .6171912
## 10% savin..  |   .6076327   .0197123    30.83   0.000     .5689973    .6462682
## 20% savin..  |   .6005696    .019405    30.95   0.000     .5625365    .6386028
## ------------------------------------------------------------------------------
## .         
## . 
## . 
## .         
## .         
## .         
## .         
## .         *--------------------------------------------------------------------
## > -------
## .         * Controlling for savings rate (x_sr) and income (x_inc)
## .         *--------------------------------------------------------------------
## > -------
## . 
## .         #delimit;
## delimiter now ;
## .         logit 
## >                 y_signup 
## >                 i.x_sr 
## >                 i.x_inc 
## >                 ,
## >                 cluster(id)
## >         ;
## 
## Iteration 0:   log pseudolikelihood = -2018.7142  
## Iteration 1:   log pseudolikelihood = -1995.9562  
## Iteration 2:   log pseudolikelihood = -1995.9418  
## Iteration 3:   log pseudolikelihood = -1995.9418  
## 
## Logistic regression                                     Number of obs =  2,988
##                                                         Wald chi2(4)  =  25.91
##                                                         Prob > chi2   = 0.0000
## Log pseudolikelihood = -1995.9418                       Pseudo R2     = 0.0113
## 
##                                  (Std. err. adjusted for 1,494 clusters in id)
## ------------------------------------------------------------------------------
##              |               Robust
##     y_signup | Coefficient  std. err.      z    P>|z|     [95% conf. interval]
## -------------+----------------------------------------------------------------
##         x_sr |
## 10% savin..  |   .0684437   .0888285     0.77   0.441     -.105657    .2425444
## 20% savin..  |   .0684025   .0866827     0.79   0.430    -.1014925    .2382975
##              |
##        x_inc |
## 02 Modera..  |   .3598903   .1230506     2.92   0.003     .1187156     .601065
## 03 Low in..  |  -.2223832   .1347092    -1.65   0.099    -.4864083    .0416419
##              |
##        _cons |   .2306932   .1097822     2.10   0.036      .015524    .4458624
## ------------------------------------------------------------------------------
## .         #delimit cr 
## delimiter now cr
## .         
## .         estimates store m2, title(Model 2)
## .         
## .         
## .         margins x_sr x_inc  
## 
## Predictive margins                                       Number of obs = 2,988
## Model VCE: Robust
## 
## Expression: Pr(y_signup), predict()
## 
## ------------------------------------------------------------------------------
##              |            Delta-method
##              |     Margin   std. err.      z    P>|z|     [95% conf. interval]
## -------------+----------------------------------------------------------------
##         x_sr |
## 5% saving..  |    .582543   .0169692    34.33   0.000     .5492839    .6158021
## 10% savin..  |   .5988406   .0170954    35.03   0.000     .5653341     .632347
## 20% savin..  |   .5988308   .0168694    35.50   0.000     .5657675    .6318942
##              |
##        x_inc |
##     01 High  |   .5685902    .023966    23.72   0.000     .5216177    .6155627
## 02 Modera..  |   .6538266   .0169193    38.64   0.000     .6206655    .6869878
## 03 Low in..  |   .5134408   .0231512    22.18   0.000     .4680653    .5588162
## ------------------------------------------------------------------------------
## .         
## . 
## . 
## .         *--------------------------------------------------------------------
## > -------
## .         * Controlling for savings rate (x_sr) and race (x_race) 
## .         *--------------------------------------------------------------------
## > -------
## . 
## .         #delimit;
## delimiter now ;
## .         logit 
## >                 y_signup 
## >                 i.x_sr 
## >                 i.x_race 
## >                 ,
## >                 cluster(id)
## >         ;
## 
## Iteration 0:   log pseudolikelihood = -2018.7142  
## Iteration 1:   log pseudolikelihood = -2014.1741  
## Iteration 2:   log pseudolikelihood = -2014.1732  
## Iteration 3:   log pseudolikelihood = -2014.1732  
## 
## Logistic regression                                     Number of obs =  2,988
##                                                         Wald chi2(6)  =   5.48
##                                                         Prob > chi2   = 0.4845
## Log pseudolikelihood = -2014.1732                       Pseudo R2     = 0.0022
## 
##                                  (Std. err. adjusted for 1,494 clusters in id)
## ------------------------------------------------------------------------------
##              |               Robust
##     y_signup | Coefficient  std. err.      z    P>|z|     [95% conf. interval]
## -------------+----------------------------------------------------------------
##         x_sr |
## 10% savin..  |   .0542916   .0885895     0.61   0.540    -.1193407    .2279238
## 20% savin..  |   .0734955   .0867636     0.85   0.397    -.0965581    .2435491
##              |
##       x_race |
##    02 Black  |   .1640889   .1377482     1.19   0.234    -.1058927    .4340704
## 03 Hispanic  |    .247453   .1558608     1.59   0.112    -.0580285    .5529345
##    04 Asian  |  -.0766394   .1515874    -0.51   0.613    -.3737453    .2204664
## 05 Other ..  |   .1369911   .1629095     0.84   0.400    -.1823056    .4562879
##              |
##        _cons |   .2655023   .0932925     2.85   0.004     .0826523    .4483523
## ------------------------------------------------------------------------------
## .                 #delimit cr 
## delimiter now cr
## .         
## .         estimates store m3, title(Model 3)
## .         
## .         margins x_sr x_race  
## 
## Predictive margins                                       Number of obs = 2,988
## Model VCE: Robust
## 
## Expression: Pr(y_signup), predict()
## 
## ------------------------------------------------------------------------------
##              |            Delta-method
##              |     Margin   std. err.      z    P>|z|     [95% conf. interval]
## -------------+----------------------------------------------------------------
##         x_sr |
## 5% saving..  |    .583155   .0172119    33.88   0.000     .5494203    .6168896
## 10% savin..  |   .5962532   .0171973    34.67   0.000     .5625471    .6299593
## 20% savin..  |   .6008547   .0169177    35.52   0.000     .5676966    .6340129
##              |
##       x_race |
##    01 White  |   .5763546   .0191245    30.14   0.000     .5388713    .6138379
##    02 Black  |   .6158279    .026796    22.98   0.000     .5633086    .6683471
## 03 Hispanic  |   .6353463   .0312103    20.36   0.000     .5741751    .6965174
##    04 Asian  |   .5575451   .0320075    17.42   0.000     .4948117    .6202786
## 05 Other ..  |   .6093987   .0339964    17.93   0.000      .542767    .6760303
## ------------------------------------------------------------------------------
## .         
## . 
## .         
## .         *--------------------------------------------------------------------
## > -------
## .         * Controlling for savings rate (x_sr) and income (x_inc) nd race(x_ra
## > ce) 
## .         *--------------------------------------------------------------------
## > -------
## . 
## .         #delimit;
## delimiter now ;
## .         logistic 
## >                 y_signup 
## >                 i.x_sr 
## >                 i.x_inc 
## >                 i.x_race
## >                 [pweight=weight_race]
## >                 ,
## >                 cluster(id)
## >         ;
## 
## Logistic regression                                     Number of obs =  2,986
##                                                         Wald chi2(8)  =  24.52
##                                                         Prob > chi2   = 0.0019
## Log pseudolikelihood = -1.329e+08                       Pseudo R2     = 0.0144
## 
##                                  (Std. err. adjusted for 1,493 clusters in id)
## ------------------------------------------------------------------------------
##              |               Robust
##     y_signup | Odds ratio   std. err.      z    P>|z|     [95% conf. interval]
## -------------+----------------------------------------------------------------
##         x_sr |
## 10% savin..  |   1.117524   .1161434     1.07   0.285     .9115745    1.370003
## 20% savin..  |   1.080143   .1096851     0.76   0.448     .8852066    1.318008
##              |
##        x_inc |
## 02 Modera..  |   1.354918   .1930014     2.13   0.033     1.024857    1.791276
## 03 Low in..  |   .7361452   .1164249    -1.94   0.053     .5399355    1.003656
##              |
##       x_race |
##    02 Black  |    1.08905   .1798112     0.52   0.605     .7879659    1.505179
## 03 Hispanic  |    1.26295   .2320033     1.27   0.204     .8810911    1.810304
##    04 Asian  |   .8667489   .1471113    -0.84   0.399     .6214709    1.208832
## 05 Other ..  |   1.386352   .2675081     1.69   0.090     .9497888    2.023577
##              |
##        _cons |   1.222752   .1658554     1.48   0.138     .9373036     1.59513
## ------------------------------------------------------------------------------
## Note: _cons estimates baseline odds.
## .         #delimit cr 
## delimiter now cr
## .         estimates store m4, title(Model 4)
## .         
## .         margins x_sr x_inc x_race
## 
## Predictive margins                                       Number of obs = 2,986
## Model VCE: Robust
## 
## Expression: Pr(y_signup), predict()
## 
## ------------------------------------------------------------------------------
##              |            Delta-method
##              |     Margin   std. err.      z    P>|z|     [95% conf. interval]
## -------------+----------------------------------------------------------------
##         x_sr |
## 5% saving..  |   .5805882   .0195626    29.68   0.000     .5422463    .6189301
## 10% savin..  |   .6068829   .0195642    31.02   0.000     .5685378     .645228
## 20% savin..  |    .598889   .0192506    31.11   0.000     .5611584    .6366195
##              |
##        x_inc |
##     01 High  |   .5818456   .0272676    21.34   0.000      .528402    .6352891
## 02 Modera..  |   .6530532   .0195919    33.33   0.000     .6146539    .6914526
## 03 Low in..  |   .5064352   .0267044    18.96   0.000     .4540955    .5587748
##              |
##       x_race |
##    01 White  |   .5800419   .0217653    26.65   0.000     .5373826    .6227012
##    02 Black  |   .6003351   .0323153    18.58   0.000     .5369983     .663672
## 03 Hispanic  |   .6347473   .0358474    17.71   0.000     .5644878    .7050069
##    04 Asian  |   .5454482   .0350514    15.56   0.000     .4767487    .6141477
## 05 Other ..  |   .6557498   .0375954    17.44   0.000     .5820642    .7294353
## ------------------------------------------------------------------------------
## .

Table 1

## 
## Regression Table 1
## ===========================================================================================
##                                                 Dependent variable:                        
##                          ------------------------------------------------------------------
##                                                       Sign Up                              
##                               (1)             (2)              (3)              (4)        
## -------------------------------------------------------------------------------------------
## Savings Rate 10%             0.125           0.126            0.126            0.127       
##                             (0.090)         (0.090)          (0.090)          (0.091)      
##                                                                                            
## Savings Rate 20%             0.089           0.090            0.090            0.082       
##                             (0.087)         (0.087)          (0.087)          (0.087)      
##                                                                                            
## Contract Length 25 Years                   -0.202***        -0.202***        -0.213***     
##                                             (0.076)          (0.076)          (0.076)      
##                                                                                            
## Contract Length 20 Pages                     -0.046          -0.046            -0.053      
##                                             (0.072)          (0.072)          (0.073)      
##                                                                                            
## Cancellation Fee 250                                          0.001            0.008       
##                                                              (0.075)          (0.075)      
##                                                                                            
## High Income                                                                    0.210       
##                                                                               (0.137)      
##                                                                                            
## Moderate Income                                                               0.561***     
##                                                                               (0.120)      
##                                                                                            
## Constant                    0.304***        0.426***        0.425***           0.118       
##                             (0.073)         (0.091)          (0.097)          (0.126)      
##                                                                                            
## -------------------------------------------------------------------------------------------
## Observations                 2,975           2,975            2,975            2,975       
## R2                           0.001           0.004            0.004            0.023       
## chi2                     1.964 (df = 2) 9.619** (df = 4) 9.619* (df = 5) 51.020*** (df = 7)
## ===========================================================================================
## Note:                                                           *p<0.1; **p<0.05; ***p<0.01

Table 2

## 
## Regression Table 2
## ==========================================================================================================
##                                                         Dependent variable:                               
##                          ---------------------------------------------------------------------------------
##                                                               Sign Up                                     
##                                  (1)                 (2)                 (3)                  (4)         
## ----------------------------------------------------------------------------------------------------------
## Savings Rate 10%                0.115               0.120               0.158*               0.159*       
##                                (0.091)             (0.091)             (0.096)              (0.096)       
##                                                                                                           
## Savings Rate 20%                0.077               0.078               0.117                0.120        
##                                (0.088)             (0.088)             (0.094)              (0.094)       
##                                                                                                           
## Contract Length 25 Years      -0.209***           -0.223***           -0.229***            -0.226***      
##                                (0.076)             (0.077)             (0.081)              (0.081)       
##                                                                                                           
## Contract Length 20 Pages       -0.065              -0.065               -0.067               -0.057       
##                                (0.073)             (0.073)             (0.076)              (0.076)       
##                                                                                                           
## Cancellation Fee 250            0.013               0.012               0.037                0.041        
##                                (0.075)             (0.076)             (0.081)              (0.081)       
##                                                                                                           
## High Income                    0.290**              0.231              0.356**              0.348**       
##                                (0.144)             (0.146)             (0.157)              (0.158)       
##                                                                                                           
## Moderate Income               0.601***            0.540***             0.535***             0.526***      
##                                (0.122)             (0.124)             (0.132)              (0.132)       
##                                                                                                           
## Black                           0.075               0.162               0.089                0.073        
##                                (0.146)             (0.148)             (0.156)              (0.157)       
##                                                                                                           
## Hispanic                        0.224              0.319**              0.169                0.160        
##                                (0.153)             (0.158)             (0.169)              (0.170)       
##                                                                                                           
## Asian                          -0.136              -0.072               -0.017               0.004        
##                                (0.151)             (0.154)             (0.164)              (0.164)       
##                                                                                                           
## Other                          0.303*              0.376**             0.440**              0.442**       
##                                (0.177)             (0.179)             (0.189)              (0.190)       
##                                                                                                           
## Renter                                            -0.327***             -0.092               -0.070       
##                                                    (0.108)             (0.116)              (0.116)       
##                                                                                                           
## More Familiar                                                          1.470***             1.478***      
##                                                                        (0.110)              (0.110)       
##                                                                                                           
## More Reviewed                                                                               0.256**       
##                                                                                             (0.101)       
##                                                                                                           
## Constant                        0.026               0.167             -0.738***            -0.905***      
##                                (0.149)             (0.157)             (0.179)              (0.189)       
##                                                                                                           
## ----------------------------------------------------------------------------------------------------------
## Observations                    2,975               2,975               2,975                2,975        
## R2                              0.028               0.035               0.178                0.182        
## chi2                     62.852*** (df = 11) 79.180*** (df = 12) 421.368*** (df = 13) 430.983*** (df = 14)
## ==========================================================================================================
## Note:                                                                          *p<0.1; **p<0.05; ***p<0.01

Odds Ratios

Table 1

## 
## Odds Ratio, Table 1
## ===========================================================================================
##                                                 Dependent variable:                        
##                          ------------------------------------------------------------------
##                                                       Sign Up                              
##                               (1)             (2)              (3)              (4)        
## -------------------------------------------------------------------------------------------
## Savings Rate 10%            1.133***        1.134***        1.134***          1.136***     
##                             (0.090)         (0.090)          (0.090)          (0.091)      
##                                                                                            
## Savings Rate 20%            1.093***        1.095***        1.095***          1.085***     
##                             (0.087)         (0.087)          (0.087)          (0.087)      
##                                                                                            
## Contract Length 25 Years                    0.817***        0.817***          0.808***     
##                                             (0.076)          (0.076)          (0.076)      
##                                                                                            
## Contract Length 20 Pages                    0.955***        0.955***          0.949***     
##                                             (0.072)          (0.072)          (0.073)      
##                                                                                            
## Cancellation Fee 250                                        1.001***          1.008***     
##                                                              (0.075)          (0.075)      
##                                                                                            
## High Income                                                                   1.234***     
##                                                                               (0.137)      
##                                                                                            
## Moderate Income                                                               1.752***     
##                                                                               (0.120)      
##                                                                                            
## Constant                    1.355***        1.531***        1.530***          1.126***     
##                             (0.073)         (0.091)          (0.097)          (0.126)      
##                                                                                            
## -------------------------------------------------------------------------------------------
## Observations                 2,975           2,975            2,975            2,975       
## R2                           0.001           0.004            0.004            0.023       
## chi2                     1.964 (df = 2) 9.619** (df = 4) 9.619* (df = 5) 51.020*** (df = 7)
## ===========================================================================================
## Note:                                                           *p<0.1; **p<0.05; ***p<0.01

Table 2

## 
## Odds Ratio, Table 2
## ==========================================================================================================
##                                                         Dependent variable:                               
##                          ---------------------------------------------------------------------------------
##                                                               Sign Up                                     
##                                  (1)                 (2)                 (3)                  (4)         
## ----------------------------------------------------------------------------------------------------------
## Savings Rate 10%                1.121               1.128               1.172                1.172        
##                                (1.095)             (1.096)             (1.101)              (1.101)       
##                                                                                                           
## Savings Rate 20%                1.080               1.081               1.124                1.127        
##                                (1.092)             (1.092)             (1.098)              (1.098)       
##                                                                                                           
## Contract Length 25 Years        0.812               0.800               0.795                0.798        
##                                (1.079)             (1.080)             (1.085)              (1.085)       
##                                                                                                           
## Contract Length 20 Pages        0.937               0.937               0.935                0.944        
##                                (1.076)             (1.076)             (1.079)              (1.079)       
##                                                                                                           
## Cancellation Fee 250            1.014               1.012               1.038                1.042        
##                                (1.078)             (1.078)             (1.084)              (1.084)       
##                                                                                                           
## High Income                     1.336               1.260               1.427                1.416        
##                                (1.155)             (1.157)             (1.170)              (1.171)       
##                                                                                                           
## Moderate Income                 1.825               1.716               1.708                1.692        
##                                (1.129)             (1.132)             (1.141)              (1.141)       
##                                                                                                           
## Black                           1.078               1.176               1.094                1.076        
##                                (1.157)             (1.159)             (1.169)              (1.170)       
##                                                                                                           
## Hispanic                        1.251               1.376               1.184                1.173        
##                                (1.166)             (1.171)             (1.184)              (1.185)       
##                                                                                                           
## Asian                           0.873               0.931               0.983                1.004        
##                                (1.163)             (1.166)             (1.179)              (1.179)       
##                                                                                                           
## Other                           1.354               1.456               1.553                1.556        
##                                (1.193)             (1.196)             (1.209)              (1.209)       
##                                                                                                           
## Renter                                              0.721               0.912                0.932        
##                                                    (1.114)             (1.123)              (1.123)       
##                                                                                                           
## More Familiar                                                          4.349***             4.382***      
##                                                                        (1.116)              (1.116)       
##                                                                                                           
## More Reviewed                                                                                1.292        
##                                                                                             (1.106)       
##                                                                                                           
## Constant                        1.026               1.182               0.478                0.404        
##                                (1.160)             (1.170)             (1.196)              (1.208)       
##                                                                                                           
## ----------------------------------------------------------------------------------------------------------
## Observations                    2,975               2,975               2,975                2,975        
## R2                              0.028               0.035               0.178                0.182        
## chi2                     62.852*** (df = 11) 79.180*** (df = 12) 421.368*** (df = 13) 430.983*** (df = 14)
## ==========================================================================================================
## Note:                                                                          *p<0.1; **p<0.05; ***p<0.01
  1. Table 1
  • Contract length of 25 years compared to 1 year remained a significant deterrent to contract acceptance rates.
  • Relative to low income, moderate and higher income respondents were more likely to accept the contract, holding th effect of savings rate, cancellation fee, and contract length constant.
  1. Table 2
  • Contract lenght remained a constant deterrance
  • Homeowner status, rent vs homeowner, was not observed as a statistically significant effect on signup rate. Likely some multicollinearity due to effect (sign) varying from model 2 to model 4.
  • After including familiarity and reviewed dummies, savings rate becomes statistically significant effect on likelihood of contract adoption.
  • More familiar with community solar implies significantly more likely to adopt contract (suggests importance of education) - odds ratio of >4 in model 3 and 4
  • In looking at contract adoption by race, Hispanics were the only group observed with a statistically significant effect in models 1 and 2. Relative to white, hispanic rates were higher. This effect is negated after additional IVs are introduces in models 3 and 4.

From Table 1, four models are presented analyzing changes in probability of sign up. Controlling for all other variables, contract length and income were found to have statistically significant effects on the rate of sign up. Contract length was found to have a strong negative impact on probability of contract adoption. For example, holding all variables constant, from model 2 we see that the odds ratio for contract length of 25 years is 0.782, meaning the group with contracts of 25 years are 0.782 times as likely as the group with contracts of 1 year of signing up, or a 21.8% decrease in odds of signing up.

Interestingly, lower income respondents were much less likely to adopt the contract, even when controlling for savings rate, contract length and number of pages, and cancellation fees. High income and medium income respondents were 1.3 and 1.7 times the odds to adopt the contract compared to low income respondents, controlling for contract attributes.

Secondary Analysis

The secondary analysis will include an ordered logit model to investigate the degree of which the same independent variables above influence the likert scale questions asked in the survey. Ordered logit models are commonly utilized with outputs of interest are categorized in discrete sequences, such as a Likert scale.

Would/Would Not Sign Up

Savings Rate

Tables 1-4 in output/regressions

Agree/Disagree

Discussion